Interested to Buy Any Domain ? << Click Here >> for more details...
if i have a delimited file as source so how can we seperate this file into three diff targets?
TCS,
2 5481if the column name in sql override is diff from the column name in source qualifier,what is the impact?
TCS,
5 9595create a mapping to retrieve the employees who are getting salary greater than average salary?
TCS,
4 10981CANNOT 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
CSC,
4 9133I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
TCS,
5 13422Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
2 11728If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
TCS,
1 7106what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
2323I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
DELL,
2 7429Post New Informatica Questions
Explain the different dimensions.
What is domain and gateway node?
how we can load rejected record's at run time?(not through bad files)
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is Index Caches size?
How many ways a relational source definition can be updated and what are they?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Why update strategy and union transformations are active? Explain with examples.
Write the program through which the records can be updated?
In informatica workflow manager, how many repositories can be created?
COM components can be used in Informatica
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
If informatica has its scheduler why using third party scheduler?
How to join three sources using joiner? Explain though mapping flow.
What is the difference between a connected look up and unconnected lookup?
