Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 10 Answers
- 15295 Views
- Emirates, IBM, I also Faced
- E-Mail Answers
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 session task and command task?
What is an active transformation?
What are the new features of Power Center 5.0?
How can we delete duplicate rows from flat files?
How do you load alternate records into different tables through mapping flow?
What is resilience time?
How we can create indexes after completing the loan process?
Is there any target staging area in informatica not staging area
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Plz can any one say me how to get the informatica certification materials and dumps
Enterprise data warehouse your projects phase by phase explain?
On which transformations you created partitions in your project?
Can we override a native sql query within informatica?
Briefly describe lookup transformation?
How to generate sequence numbers using expression transformation?
