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
- 3 Answers
- 6367 Views
- I also Faced
- E-Mail Answers
Answer Posted / kal
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 |
Post New Answer View All Answers
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
when will use SQL override in a lookup transformation?
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
what are the reports developed in sap bw project and what is the requirement for developing it?
what is the difference steps for data modeling?
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 are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is lookup table in etl testing?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
Explain the use lookup tables and Aggregate tables?
What is data cleaning?
what is session partitioning?
What are the three tiers in etl?
Identifying the bottlenecks in various components of Informatica and resolving them.
Compare etl & elt?
