Interested to Buy Any Domain ? << Click Here >> for more details...
How to Join Tables my Source is having 15 table target is
one?
- 4 Answers
- 7880 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / narender_kusa
if u have n sources u need n-1 joins..
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the different ways to implement parallel processing in informatica?
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
wf dont have integration severances how you can run?
What is informatica etl tool?
write a query to retrieve the latest records from the table sorted by version(scd)
Under which circumstances, informatica server creates reject files?
What is a joiner transformation?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is aggregator transformation in informatica?
What are the main issues while working with flat files as source and as targets ?
How do you promote a non-reusable transformation to reusable transformation?
What is a standalone command task?
What is a code page?
What is meant by a domain?
How to elaborate powercenter integration service?
