if you require only 5 rows in the target we can use 5 target aliases and

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

Question Posted / kuttu

3 Answers
6104 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

How etl testing is different from database testing?

521

what is the difference between cardinality and Nullability?

2832

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

1835

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

540

what do u do when DB time takes more?in sap bi

1781

What is etl process. How many steps etl contains explain with example?

515

explain the methodology of Data Warehousing?(Polaries)

1802

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?

1846

what are the concerns of OLTP and DSS systems?

1973

What is cube grouping?

567

Which transformation we use to convert 'NA' to 'Not Available'

855

list and discuss two approaches for updation of target table in Informatica and how they are different.

1734

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?

1451

Explain the difference between etl tool and olap tools?

538

what is the difference steps for data modeling?

2081