What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
933What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
1116What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
1 1424Post New Informatica Questions
Explain your project of banking domian.
I have a flat file, want to reverse the contents of the flat file
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How to differentiate between the active and passive transformations?
How can we use batches?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Make a note of the quantity vaults made in informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
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
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is a connected transformation?
How do you migrate data from one environment to another?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Could you explain what is enterprise data warehouse?