What is meant by query override?
No Answer is Posted For this Question
Be the First to Post Answer
If informatica has its scheduler why using third party scheduler?
how many types transformations supported by sortedinput?
In joiner, how to load Master table in Target?
Under what condition selecting sorted input in aggregator may fail the session?
Difference between Data and Index Caches?
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files
Explain about Recovering sessions?
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?