What are the different components of powercenter?
No Answer is Posted For this Question
Be the First to Post Answer
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Two Default User groups created in the repository are ____ and ______
what is workflow varible
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
what is curr val use for in sequence generator?
What is deployemnt groups, Lables, query and dynamic deployment group.
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
how may sources can be used in a mapping at a time?(limit)
What are the methods for creating reusable transforamtions?
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
tell me 5 session failure in real time how can you solve that in your project?
how many session run unix environment what command using ?