IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ?
- 4 Answers
- 19231 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / divi
Alternative to Lookup id Joiner.we need to import source
structure of target in Source Analyser and bring that into
mapping and use it for comparison like Lookup.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
4 yrs etl devloper roles and responsibilities?any body give solutions
Differentiate between reusable transformation and mapplet.
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
Briefly explain the aggregator transformation?
How to use procedural logic inside infromatica?
How can informatica be used for an organization?
What is transformation?
What are the different versions of informatica?
list out all the transformations which use cache?
How might you approve all mappings in the archive all the while?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are the types of presistent cache in look up tr.
Explain lookup transformation is active in informatica
What are the differences between source qualifier and joiner transformation?
What is a dimensional model?
