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
Answers were Sorted based on User's Feedback
The simplest thing U can do is
while importing the source flatfile using "Flat File Import
Wizard"
In Step1 choose-> FixedWidth
in the step2 -> click and create a column or tab on the
field then U can import them as 2 fields
1. 01/08/2008
2.(DD/MM/YYYY)
U can ignore the second column and use the first one.
second method is by taking only the date value in
Expression Transformation.
Hope this of any help
Kal
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / 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 |
what is a test load?
what is the difference between shortcut of an object and copy of an object? compare them?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
what is pmrep command?
Can we create Hierarchies in generic datasources?
When do we analyze the tables?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
how do u decide whether u need to do aggregations at database level or at Informatica level?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
explain the methodology of Data Warehousing?(Polaries)
What is the difference between project backlog and product backlog?