Interested to Buy Any Domain ? << Click Here >> for more details...
In a mapping i have three dimensions. If i want to pass a
same surrogate key value to all the three dimensions by
using one sequence generator is possible?If the mapping is
containing single flow? And in the same case if the mapping
is contaning 3 flows for the three dimensions then by using
one sequence generator can we populate surrogate key (same
value) to all the three dimensions?
- 6 Answers
- 13929 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / abhishek
yes offcourse we can do it
for understandi this you can refer SCD2 version it haapens
same like ur qustion
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to extract the informatica rejected data?
In which transformation you cannot drag ports into it?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Enlist the tasks for which source qualifier transformation is used.
Explain sql transformation in script mode examples in informatica
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
which one is better performance wise joiner or look up
What are data-driven sessions?
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
tell me the rules and responsblites in our project(my project is development)
How to convert multiple rows to single row (multiple columns) in informatica
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
can anyone suggest best free Talend data integration training online
Slowly changing dimensions, types and where will you use them
How to elaborate tracing level?
