Interested to Buy Any Domain ? << Click Here >> for more details...
If one flat file contains n number records., we have to load
in target from 51 to 100.. how to use expressions in
Informatica..?
- 2 Answers
- 6323 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkateshmalneni
Generate sequence by using sequence generator or by using expression t/r
connect the output to the filter t/r in filter write the condition as sno>=51 and sno=100
connect it to the target
src--->sq---> expression--->filter--->target
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the maplet?
Enlist the various types of transformations.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
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 ?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Clarify the utilization of aggregator cache record?
What is a difference between complete, stop and abort?
What is fact table? Explain the different kinds of facts.
What is a snowflake schema?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is the Rank index port in Rank transformation?
Differentiate between sessions and batches?
What is a surrogate key?
