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
What is decode in informatica?
can you please explain me pre session and post session options?
Difference between Target-based loading and constraint-based loading?
In which transformation you cannot drag ports into it?
Explain dynamic target flat file name generation in informatica
what is mean by complex business rule ?
How to elaborate tracing level?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
without table how to come first record only in oracle?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is flashback table ? Advance thanks
Briefly describe lookup transformation?
Explain the different lookup methods used in informatica?
How to open an older version of an object in the workspace?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab