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
7049 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

What is staging area referring to?

1049

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

921

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

2003

what is Forward,Reverse and Re_engineering?

2178

What are the ETL Testing Operations?

987

What is cube grouping?

995

Difference between flat files and relational sources?

2174

what is the difference steps for data modeling?

2047

what is an ETL or ETT? And what are the different types?

7434

what is pmrep command?

11483

How can we use external procedural logic in informatica?

871

What is etl tool in hadoop?

837

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?

1819

Explain the key challenges that you face while performing etl testing.

946

what are Lookup caches options? Including persistent caches.

1895