What are types of partition primary index (ppi) in teradata?

1052

What data formats does Redshift Spectrum support?

5

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1796

What is a cursor? Within a cursor, how would you update fields on the row just fetched?

1182

List out some of the air commands used in abintio?

1388

Differences between connected and unconnected lookup?

1218

What is an expression transformation in informatica?

1037

What is the extension of file to save template?

1007

How to do unit testing in informatica?

1171

Explain in detail scd type 2 through mapping.

1041

What is fact table? Explain the different kinds of facts.

1076

describe about physical data integration? : Sas-di

1045

Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

1344

For what purpose would you use the RETAIN statement?

1524

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1013