![]() ![]() ![]() There is a source table containing 2 columns Col1 and Col2 with data as follows:ĭesign a mapping to load a target table with following values from the above mentioned source:ĭesign an Informatica mapping to load first half records to 1 target while other half records to a separate target. There is a source table that contains duplicate rows.Design a mapping to load all the unique rows in 1 target while all the duplicate rows (only 1 occurence) in another target. Design a mapping so that the target table contains 3 rows as follows: There is target table containg only 1 column Col. There is only 1 row in the table as follows: We have a target source table containing 3 columns : Col1, Col2 and Col3. Without using aggregator transformation calculate sum and average of sal by dept wise. So for the above requirement i have tried with full outer join.But that is not worked for me. I have Source as a Table and I want to load the data in Flat file Target with one Header and one Trailer
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |