HOW TO YOU LOAD TIME DIMENSION
what is the flat file partition and where have to specify it
can we import source table without using source qualifier? if yes then how? if no then why?
what is the diff b/w cached and unchaed look ups
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
Why the workflow is failed after running two hours in informatica?
What are the Advantages of de normalized data?
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
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?
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.
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?