I have table name called Team and I have name and DOJ in
that table in oracle, when I retrive the table in
Informatica DOJ shows with date and time , I want want to
know is it possible to get only date(MMDDYYYY) in the date
data type,
Answer Posted / bk
TO_CHAR(DOJ_port, 'MMDDYYYY')
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the differences between source qualifier and joiner transformation?
Explain your project of banking domian.
How do you load only null records into target?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Explain sessions?
What is meant by target load plan?
What are the uses of etl tools?
What are active and passive transformations?
Mention few power centre client applications with their basic purpose?
Can we create a node as a gateway node and the same node can be assigned to a grid?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is Cognos script editor?
What is the use of an aggregator cache file?