Interested to Buy Any Domain ? << Click Here >> for more details...
How to load only the first and last record of a flat file into
the target?
- 3 Answers
- 9721 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / yaseen
After SQ place 2 Rank T/R and a reusable sequence generator T/R having start value 1. In 1st Rank give the top 1 and in 2nd Rank set bottom 1
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What is target load order?
How to load data in informatica ?
Write the unconnected lookup syntax and how to return more than one column.
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
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
Explain the code page compatibility?
what is the Default Source Option For Update Strategy Transformation?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Briefly define a session task?
What are the different options available for update strategy?
How to go to the older version for a mapping?
How can we delete duplicate rows from flat files?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
