What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2596

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2140

what are the different types of fact structures?

1115

What is the purpose of pivot stage and types of containers in datastage

1049

What are the types of containers and how to create them?

993

What are the steps involved in the process flow of the sql statement through channel attached system?

1121

What are components of reportnet?

1087

Explain if a flat file cotains 1000 records how can I get first and last records only?

940

What is the Rank index port in Rank transformation?

1073

What is a rollup component?

1143

what are relationships?

1056

What is data warehosuing hierarchy?

1188

Differentiate between a repository server and a powerhouse?

1132

Different phases of multiload?

1029

Explain difference between powerplay transformer and power play reports?

966