we hava a flat file having more than 1000 records and two
targets. i have to write first half of the rows into first
targets and next half of rows into second target. how can i
do in informetica??
Answer / naveen
simple, use the router transformation. when u r able to
find which is the first half and which is the second half
exactly
But how to find ?
thats the second question , the clue is we can use sorter ,
aggregator , router itself to do this job.
Is This Answer Correct ? | 0 Yes | 0 No |
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
What is abap? What are idocs?
Explain different types of partitioning?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
how does the server recongnise the source and target databases.Elaborate on this
State the differences between shortcut and reusable transformation
how do u implement unconn.stored proc. in a mapping?
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
What is a staging area? What is the purpose of a staging area?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
What are your responsibilities as an etl tester?
What are materialized views & where do we use them?