i have a source which relational.I am trying to populate to target flat f

Advertise your Business Here

Refer this Site

Login | Sign Up


	Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff HERE

Categories >> Software >> Data Warehouse >> Informatica

Teradata Interview Questions

Business Objects Interview Questions

Cognos Interview Questions

Informatica Interview Questions

Crystal Enterprise Suite Interview Questions

Actuate Interview Questions

Ab Initio Interview Questions

Data Stage Interview Questions

SAS Interview Questions

Micro Strategy Interview Questions

ETL Interview Questions

Data Warehouse General Interview Questions

Question

i have a source which relational.I am trying to populate to 
target flat file with one column for daily date which is 
sysdate.
I want to populate the sysdate coulmn with DD/MM/YYYY 
format.
kindly provide a solution for this..my clear that my target 
is flat file.

Question Submitted By :: Rakesh

I also faced this Question!!

Rank

Answer Posted By

Re: i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.

Answer
# 1

In expression transformation create one out put port, and 
write like: TO_DATE('SYSDATE'.'DD/MM/YYYY').
Connect this port to target.

Is This Answer Correct ?

1 Yes

0 No

Prabhas

Answer
# 2

In expression write following if target field is defined
with DATE datatype:
TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY'))

If target field defined with character datatype then use:
TO_CHAR(SYSDATE,'DD/MM/YYYY')

Is This Answer Correct ?

1 Yes

0 No

Aakansha

Question	Asked @	Answers
Other Informatica Interview Questions


What is ThroughPut in Informatica, How it works, Where I can find this option to check ?	CTS	4
what is diffrence b/w joner and union transfermation		4
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..		1
What is metadata reporter?		1
why dimenstion tables are denormalized in nature ?		1
what is the process we used in joiner transformation,there is no matching column in sources?		2
how to obtain performance data for individual transformations.		2
can we generate reports in informatica ? How?		2
what is parallel querying and what r hints.		1
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?		2
surrogate keys usage in Oracle and Informatica?	Oracle	3
what are the differences between powercenter 8.1 and powercenter 8.5?		1
What is power center repository?		1
What are the session parameters?		2
what is incremantal aggregation?		1
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in		1
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?		2
what is worklet and what use of worklet and in which situation we can use it?		2
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/		3
What are the basic needs to join two sources in a source qualifier?		4

For more Informatica Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

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