i have to extract data from a flat file.the flat file has 10
records.i have to extract the 1st and 5th record every
time.how is it done.
Answer Posted / sanjay
1. Method
We can do it through
sq->Exp Trns->filter-->Target
!
SG
In filter trans by giving a condition "NUM=1
or NUM=5" we can get the result.
* But if you run the wf next time u need to change the NUM
value bcoz sq increments the value accrdng to the defined
condition whenever it runs the session.
2. Method
We can do it through Router trns
SQ—-Exp—Router--Target1 & Target2
!
SG
In Ist group NUM=1 & in 2nd group NUM=5.
where we'll define two groups, One for row 1 and other for
row 5.
* we need to chng the SG value every time
3. method
We can do it through parameters & variables
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Partition, what happens if the specified key range is shorter and longer
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How many ways are there to do 'remove duplicate records in informatica'?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is session task and command task?
Explain what is informatica metadata and where is it stored?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What do you mean by filter transformation?
Explain informatica architecture - version 8 / 9
What are the differences between joiner transformation and source qualifier transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is InformaticaPowerCenter?
What are the types of data warehouses?
What is the use of target designer?