Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ankit kansal
Hi,
I have created one example closely have a look. I hope it ll help you.
follow the link
http://deepinopensource.blogspot.in/2013/07/date-dimension-using-informatica.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean incremental aggregation?
Explain sessions?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is Cognos script editor?
Explain pmcmd command usage in informatica
Explain sessions. Explain how batches are used to combine executions?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How to generate sequence numbers?
What is intricate mapping?
Design a mapping to load the cumulative sum of salaries of employees into target table?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
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 an unconnected transformation?
