Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / subarna roy
We can write a query thru Sql transformation and delete specific records from flat file.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Design a mapping to load a target table with the following values from the above source?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain Dataware house architecture .how data flow from intial to end?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Write the unconnected lookup syntax and how to return more than one column.
What is pmcmd command?
What are some examples of informatica etl programs?
What are junk dimensions?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Which transformation should we use to normalise the COBOL and relational sources?
How to use procedural logic inside infromatica?
