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

List few etl bugs?

0 Answers  

my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica

1 Answers   HCL,

how do u implement scheduling in Informatica?

1 Answers   Cognizant,

Can u access a repository created in previous version of Informatica?

1 Answers   DELL,

Is hadoop a etl tool?

0 Answers  

WHY CANT WE SEE THE DATA IN DATASET

1 Answers   IBM,

what are the reports developed in sap bw project and what is the requirement for developing it?

0 Answers   Maersk,

How to know informatica conslole password??

0 Answers  

what is a worklet?

0 Answers  

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

0 Answers  

what is the difference steps for data modeling?

0 Answers  

Explain about round-robi?

0 Answers  

For more ETL Interview Questions Click Here
Categories