Answer Posted / sudhar
Use the Dual Table as dummy table and use the Normalizer to
generate required number of rows then apply what ever logic
required to populate the Target.
For example you can create a calendar for the entire year
with the one record from the dual table using the normalizer.
But with out any source the mapping cannot be created and u
need some dummy source like the above to populate the Target.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the measure objects?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
explan ur project architecture?
Slowly changing dimensions, types and where will you use them
What is the difference between a connected look up and unconnected lookup?
Reusable transformation and shortcut differences
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How many ways are there to create ports?
Define mapping and session?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Under what condition selecting sorted input in aggregator may fail the session?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is the use of source qualifier?
How to extract sap data using informatica? What is abap? What are idocs?
