What is the Hierarchy of DWH?1 6272
How many repositories can we create in Informatica?3 6318
What is surrogate key?9 20241
What is aggregate awareness?1 8084
Explain reference cursor?1 7817
What are parallel querys and query hints?1 6583
While importing the relational source defintion from database,what are the meta data of source U import?1 4102
Howmany ways yoU can update a relational source defintion and what are they?1 4232
Where should yoU place the flat file to import the flat file defintion to the designer?4 7984
To provide support for Mainframes source data,which files r used as a COBOL files1 2972
Which transformation should u need while using the cobol sources as source defintions?2 3474
How can yoU create or import flat file definition in to the warehouse designer?2 6645
what is a transforamation?5 4635
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is standalone command task?
What are the tasks that source qualifier perform?
What is the need of an ETL tool?
What is pmcmd command?
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
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How many transformations can be used in mapplets.
What is data movement mode in Informatica and difference between them?
Define joiner transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain joiner transformation in informatica
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the features of complex mapping?
How can we improve session performance in aggregator transformation?