Interested to Buy Any Domain ? << Click Here >> for more details...
how to join the 2 different table with different columns in
informatica?
- 5 Answers
- 23696 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / anoosha
by using joiner transforamation we can join or merge the
different columns from two different table at informatica....
eg:emp;customer or dept table tak d common fields by dat
join d 2tables....
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is enterprise data warehousing?
4 yrs etl devloper roles and responsibilities?any body give solutions
explain one complex mapping with logic? sales project?
What is the format of informatica objects in a repository?
What is workflow? What are the components of the workflow manager?
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
Which are the different editions of informatica powercenter that are available?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Make a note of the quantity vaults made in informatica?
Mention a few design and development best practices for informatica?
What is option by which we can run all the sessions in a batch simultaneously?
Explain the pipeline partition with real time example?
Define mapping and session?
What is rank transformation in informatica
write a query to retrieve the latest records from the table sorted by version(scd)
