Without using any transformations how u can load the data into
target?
Answer Posted / sunil
we cant load the data from source to target with out using
any transformation
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is data movement mode in Informatica and difference between them?
Explain the types of transformations?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Which is the t/r that builts only single cache memory?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Can anyone tell me the new features in Informatica 9 Version?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Explain the shared cache and re-cache?
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
Which development components of informatica have the highest usage?
Briefly explain the aggregator transformation?
Explain the aggregator transformation?
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?
can anyone suggest best free Talend data integration training online
What is flashback table ? Advance thanks