Interested to Buy Any Domain ? << Click Here >> for more details...
A mapping contains
(1) Source Table S_Time ( Start_Year, End_Year )
(2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
- 1 Answers
- 4649 Views
- I also Faced
- E-Mail Answers
Answer / pati
Day = to_char(sysdate,'Day')
Date = to_char(sysdate,'DD')
Month = to_char(sysdate,'Month')
Year = to_char(sysdate,'YYYY')
Quater = to_char(sysdate,'Q')
| Is This Answer Correct ? | 3 Yes | 2 No |
How to list Top 10 salary, without using Rank Transmission?
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
write a query to retrieve the latest records from the table sorted by version(scd)
what happens when a batch fails?
Explain in detail about scd type 1 through mapping.
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
replace multiple spaces with single space.
If we set dd_insert in mapping and Delete in session properties what will happen.?
Can anyone briefly describe abt audit table loading?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is joiner cache?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
Teradata 
