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
- 15596 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 size of u r database?
Describe an informatica powercenter?
What are the advantages of using informatica as an etl tool over teradata?
In which transformation you cannot drag ports into it?
How to partition the Session?
what is the size of u r source(like file or table)?
server hot-ws270 is connect to Repository B. What does it mean?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Write the program through which the records can be updated?
Differentiate between a database and data warehouse?
What does reusable transformation mean?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
explain one complex mapping with logic? sales project?
Write the unconnected lookup syntax?
Explain what is informatica metadata and where is it stored?
