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
- 14939 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
Why filter transformation is an active one?
What is informatica? Why do we need it?
how we can load rejected record's at run time?(not through bad files)
During the running session, output files are created by informatica server. Enlist few of them.
How do you promote a non-reusable transformation to reusable transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How can informatica be used for an organization?
What are pre and post-session shell commands?
How to load last n records of file into target table - informatica
How to do unit testing in informatica? How to load data in informatica ?
Enlist the tasks for which source qualifier transformation is used.
Explain the use of aggregator cache file?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Can anyone tell me the new features in Informatica 9 Version?
Can we create a Integration service without a Repository service and vice versa?
