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
- 15321 Views
- Emirates, IBM, I also Faced
- E-Mail Answers
Answer Posted / bala
using sequence generator we can achieve desired result
enable SG properties as
start value=1
end value=5
enable cycle....
then in expression write a condition that
if SG values(num) are 1 and 5 then pass them into filter
iif(num=1 and num=5,true,false)
in filter ...make this column condition as true...
u will get every 1st and 5th record from your source
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the reusable transformations?
design of staging area?
Explain the different dimensions.
What is the difference between writing a joiner query in ANSI style and THETA style?
In informatica workflow manager, how many repositories can be created?
What are active transformations.
How to join three sources using joiner? Explain though mapping flow.
4 yrs etl devloper roles and responsibilities?any body give solutions
What is workflow? What are the components of workflow manager?
Where are the source flat files kept before running the session?
What does reusable transformation mean?
Mention few power centre client applications with their basic purpose?
Explain in detail scd type 2 through mapping.
How do you change a non-reusable transformation to reusable transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
