How do you load first and last records into target table?

660

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2319

How big was your fact table

1310

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1864

What are the features of complex mapping?

639

How many number of sessions can one group in batches?

684

Explain the mapping variable usage example in informatica

629

where to store informatica rejected data?

672

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1453

Explain why we use partitioning the session in informatica?

607

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

1460

Where can we find the throughput option in informatica?

598

Define enterprise data warehousing?

630

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5562

Define sessions in informatica etl?

611