ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  ETL
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
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 Submitted By :: Amrita
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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
Answer
# 1		 
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 1 No
Kal
 
  Re: 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
Answer
# 2		 
In expression transfromation 
to_date(datecolumnname,dd/mm/yyyy) and pass this link upto 
target
 
Is This Answer Correct ?    1 Yes 1 No
Bhagya
 
 
 
  Re: 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
Answer
# 3		 
if you require only 5 rows in the target we can use 5 
target aliases and acheive it.
 
Is This Answer Correct ?    0 Yes 0 No
Kuttu
 

 
 
 
Other ETL Interview Questions
 
  Question Asked @ Answers
 
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.  1
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.  1
what is the indicator file and where it is used?  1
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.  2
what is HISTOGRAM? how to generate statistics?  1
Eliminating of duplicate records without using dynamic lookups IBM3
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.  3
how do u set the size of block buffer?  1
what is the meant by Normalization and de-normalization?  1
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
Eliminating of duplicate records without using dynamic lookups  1
what is the difference between normal & bulk loading? and which one is recommended ? why?  1
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys  1
what are variable ports and list two situations when they can be used? Satyam3
Difference between flat files and relational sources?  1
what is the difference between OLTP database and data warehousing database?  1
how do u implement unconn.stored proc. in a mapping?  1
if u can't find what you are looking for in lookup table, how do you handle?  1
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?  1
what happens if the info.server doesn't find the session parameter in the parameter file?  1
 
For more ETL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com