what is pre and post sql and what is diff between source
presql and target pre sql
Answer / priyaraj
Pre SQL means that the integration service runs SQL
commands against the source database before it reads the
data from source.
Post SQL means IS runs SQL commands against target database
after it writes to the target.
Is This Answer Correct ? | 26 Yes | 3 No |
Explain in detail about scd type 1 through mapping.
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
how to remove staging area
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
How to display First letter of Names in Caps?
What are multi-group transformations?
r u done any partitions in ur project?
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,
Which is the t/r that builts only single cache memory?
What is a connected transformation?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use