when u connect the repository for the first time it asks you
for user name & password of repository and database both.But
subsequent times it asks only repository password. why?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)

1 Answers  


How to Check the source record count from traget table.

5 Answers   IBM,


When do we analyze the tables? How do we do it?

0 Answers  


how do u extract data from different data sources explain with an example?

0 Answers  


When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.

3 Answers  


what is the difference between normal & bulk loading? and which one is recommended ? why?

2 Answers  


Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

2 Answers   Cognizant, IBM,


how to connect to a flatfile through ftp in informatica

1 Answers   TCS,


Do we need an ETL tool? When do we go for the tools in the market?

0 Answers  


Eliminating of duplicate records without using dynamic lookups

3 Answers  


how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

0 Answers  


Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

0 Answers  


Categories