How can one know that a table has indexes and is partitioned? How data will be

How can one know that a table has indexes and is
partitioned? How data will be pulled from Partitions in
Oracle for Informatica?

Question Posted / riju

1 Answers
4174 Views
I also Faced
E-Mail Answers

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitio..

Answer / hari

to look at the explain plan of the sql query which is issue
to database from infomatica.
have a look at the user_indexes with
table_name=<<TABLENMAE>>
have a look at user_tab_partition where
table_name=<<TABLE_NAME>>
TABLENAME, which are used in the informatica sql query...

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More Informatica Interview Questions

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers KPIT,

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers

What is the target load order?

3 Answers HCL, Informatica,

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers CTC,

What is joiner transformation?

0 Answers

what is mapping parameter?

2 Answers Cap Gemini,

Please let me know how to make encryption and decryption with example?