Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category

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 / amrita

Answers were Sorted based on User's Feedback



Hello all, Source Table(Flat File):- Target Table(Flat File):- Date ..

Answer / 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

Hello all, Source Table(Flat File):- Target Table(Flat File):- Date ..

Answer / bhagya

In expression transfromation
to_date(datecolumnname,dd/mm/yyyy) and pass this link upto
target

Is This Answer Correct ?    3 Yes 1 No

Hello all, Source Table(Flat File):- Target Table(Flat File):- Date ..

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

Post New Answer

More ETL Interview Questions

Explain etl mapping sheets?

0 Answers  

what is the difference steps for data modeling?

0 Answers  

List few etl bugs?

0 Answers  

what is the difference between normal & bulk loading? and which one is recommended ? why?

2 Answers  

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

0 Answers   Accenture,

What is ROWID explain ?

2 Answers   Wipro,

What are the different etl testing categories as per their function?

0 Answers  

what types of repositories we can create in informatica? in real time in which type of repository we will work on?

2 Answers  

what is meant by drill through?(Mascot)

1 Answers  

What are various etl tools in the market?

0 Answers  

What are cubes and olap cubes?

0 Answers  

what is the meant by Normalization and de-normalization?

2 Answers  

For more ETL Interview Questions Click Here
Categories