Interested to Buy Any Domain ? << Click Here >> for more details...
sorce is a flatfile only 1st and last row should insert to
target how will u do?
- 2 Answers
- 8960 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / balu
sourcce --> source qualifier--> sequence generator--
>expression trns-->target
generate sequence for the source data after that in
expression transformation use min and max function on
sequece then connect to target.
| Is This Answer Correct ? | 6 Yes | 5 No |
Answer / mike
well If your source is a flatfile and you are loading it in
to relational database or a flat file again, then you can
use union transformation to insert the first and last row
correct me if i was wrong
| Is This Answer Correct ? | 1 Yes | 5 No |
tell me 7.x and 8.x diferrencess(but not transformations)
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
Explain incremental aggregation in informatica
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
how can we calculate fact table size?
What is joiner cache?
What are the tasks that source qualifier perform?
What are the methods for creating reusable transforamtions?
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
COM components can be used in Informatica
I have source like this 1:2;3. so i want to load the target as 123
Teradata 
