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 |
CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
Eliminating of duplicate records without using dynamic lookups
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
can be used COM component in Informatica ?
What are the new features of informatica 9 version?
Can we create Hierarchies in generic datasources?
Explain the key challenges that you face while performing etl testing.
Explain etl mapping sheets?
What is grain of fact?
What is data modeling and data mining?
What is a mapping, session, worklet, workflow, mapplet?