Interested to Buy Any Domain ? << Click Here >> for more details...
if soource is having 10 records how will u insert 20
records to target
- 6 Answers
- 12280 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / saravana
we can user Normalizer transformation, to convert a row into double row and then load it into target
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain in detail about scd type 1 through mapping.
What is target designer and target load order?
Explain lookup transformation is active in informatica
How do you manage the Parameter files while migrating your data from one environment to another environment?
How do we call shell scripts from informatica?
What is a joiner transformation and why it is an active one?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
tell me about your project functionality
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 main issues while working with flat files as source and as targets ?
How many types of sessions are there in informatica.please explain them?
Can we get 1st record through Informatica(without sequence number).
What are the limitations of joiner transformation?
