What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
Answer / hari
Parameter file is text file which contains mapping variables and mapping parameters for mappings , sessions an workflows.
| Is This Answer Correct ? | 0 Yes | 0 No |
can we import source table without using source qualifier? if yes then how? if no then why?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
explain different types of modeling.
What do you mean by filter transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
scenario
what is meant by data driven.. in which scenario we use that..?
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
what is difference between dimention table and fact table?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
What is pmcmd command?