Hello all,
Source Table(Flat File):- Target Table(Flat File):-
Date Date
01/08/2008(DD/MM/YYYY) 01/08/2008
02/08/2008
03/08/2008
04/08/2008
05/05/2008
My requiremnt is this. I need to do it by informatica,Plz
tell me how can i do it?
Thanks
Answer Posted / kuttu
if you require only 5 rows in the target we can use 5
target aliases and acheive it.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what are the data modeling tools you have used?(polaris)
What is full load & incremental or refresh load?
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.
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is a mapping?
What are your responsibilities as an etl tester?
can cubes contain measures ?
Do we need an etl tool?
what are the reports developed in sap bw project and what is the requirement for developing it?
how do u extract data from different data sources explain with an example?
Explain me ETL project architecture in Detail?
Is apache nifi an etl tool?
what is the difference between cardinality and Nullability?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
What is Data Vault???