Interested to Buy Any Domain ? << Click Here >> for more details...
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??
- 1 Answers
- 5418 Views
- I also Faced
- E-Mail Answers
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 |
What are the types of Data Warehouse applications?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
Define Dynamic push down optmization?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Explain etl mapping sheets?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What is cube grouping?
how to connect to a flatfile through ftp in informatica
what are variable ports and list two situations when they can be used?
what are the different Reporting and ETL tools available in the market?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
what happens if the info.server doesn't find the session parameter in the parameter file?
Teradata 
