how to connect to a flatfile through ftp in informatica
Answer / sri
Create FTP connection in workflow manager. In
session->mapping, assign created ftp connection to
source(flat file).
Is This Answer Correct ? | 10 Yes | 2 No |
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
Explain about hash partitioning?
what is the difference between cubes and package in cognos
what is meant by drill through?(Mascot)
What are the key benefits of ETL Testing?
Define Dynamic push down optmization?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
explain the methodology of Data Warehousing?(Polaries)
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
can cubes contain measures ?
how would u estimate the size of Aggregator transform data and index cache?