Interested to Buy Any Domain ? << Click Here >> for more details...
i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
- 7 Answers
- 14082 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / sameer
If ur source as a flat filemail then we uses first expression transformation and we write expression v1=v1+1 and one output port o1=v1 then after filter transformation and in there filter conditions just write o1 <=7 But if ur source as a relational source then we write select * from table-name
Where rownum <=7
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Do you find any difficulty while working with flat files as source and target?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Name at least 5 different types of transformations used in mapping design and state the use of each.?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Make a note of the quantity vaults made in informatica?
How do you migrate data from one environment to another?
How can we use batches?
Explain target update override in informatica
What are the different options available for update strategy?
Explain pushdown optimization and types in informatica
What is status code in informatica?
What are the guidelines to be followed while using union transformation?
What is an aggregator transformation?
What is rank transformation in informatica
