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


	SiteMap shows list of All Categories in this site.

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 the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .		3
how do u use sequence created in oracle in informatica? Explain with an simple example	CTS	4
wat s mapping parameter and mapping variable? how do you set that in a mapping?		2
What are the Differences between connected and unconnected lookup?		3
how many tasks are there in informatica ?	TCS	3
why dimenstion tables are denormalized in nature ?		1
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")		1
what is galaxy repository?		1
What is A complex mapping?		2
Can you copy the session to a different folder or repository?		2
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how	CTS	3
what is polling?		1
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???	CTS	5
how many types transformations supported by sortedinput?		3
what happens when a batch fails?		3
daily how much amount of data send to production?	HSBC	3
what is worklet and what use of worklet and in which situation we can use it?		2
what is the logic will you implement to load data into a fact table from n dimension tables?	TCS	2
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance		2
how can u tune u r informatica mapppings	CTS	2

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