Answer Posted / gsr
When you are using Flat File source you usually get the
header files separately from the data files. You may get
source data in more than one file. In such cases you give
the paths of all the data files in one file for eg say
list.txt. This file is called the list file. In the session
edit task window instead of giving the source filename you
enter the name of the list file - list.txt and in source
filetype you make it indirect.
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Explain the code page compatibility?
Explain lookup transformation source types in informatica
If informatica has its scheduler why using third party scheduler?
where to store informatica rejected data? How to extract the informatica rejected data?
What is the cumulative sum and moving sum?
How to start a workflow using pmcmd command?
What is meant by incremental aggregation?
What is sorter transformation?
what is size of u r database?
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.
what is mean by complex business rule ?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?