How to create or import flat file definition in to the warehouse designer?

1026

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.

2807

Why filter transformation is an active one?

934

Describe data concatenation?

1008

Explain target update override in informatica

1048

what is SDLC way of code development?

1972

What is event and what are the tasks related to it?

1060

design of staging area?

1970

What is domain in terms of informatica?

961

What is workflow manager?

993

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

921

What is incremental aggregation?

1020

Please let me know how to make Data masking in informatica..

1667

What is xml source qualifier transformation in informatica?

1181

What are the types of caches in lookup? Explain them.

926