Without source how to insert record to target?

Answers were Sorted based on User's Feedback



Without source how to insert record to target?..

Answer / raj

Without source you can not create mapping...

Is This Answer Correct ?    13 Yes 2 No

Without source how to insert record to target?..

Answer / 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

Without source how to insert record to target?..

Answer / giri

Without Source means no data upload data arem ethod

1. Source qualifier use to Pre sql and post sql generate sql
query.

Is This Answer Correct ?    1 Yes 0 No

Without source how to insert record to target?..

Answer / snjsngh15

Using mapplet designer we can create mapping think how then I will explain guys it's possible

Is This Answer Correct ?    0 Yes 0 No

Without source how to insert record to target?..

Answer / raja

used to parametrs and Hot code values.

Is This Answer Correct ?    2 Yes 3 No

Without source how to insert record to target?..

Answer / krishnakanth

Hi Sudhar........Thanks for the answer. Its really very
helpful.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  


What are Rapid changing dimensions?

1 Answers  


explain different levels in pushdown optimization with example?

2 Answers   TCS,


What is a filter transformation and why it is an active one?

0 Answers  


i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,


How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,


What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,


What are the mapping paramaters and mapping variables?

1 Answers  


Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,


Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  


a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,


Which transformation should u need while using the cobol sources as source defintions?

2 Answers  


Categories