Interested to Buy Any Domain ? << Click Here >> for more details...
task is running successfully but data is not loded why?
- 2 Answers
- 7482 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bala govi
Either your SQL Override is not reading any records, or
your update stregy is not using the correct condition or
check the task SQL Override and check the properties and
make sure "Enable Test Load" is turned off.
Hope this helps
Bala
| Is This Answer Correct ? | 0 Yes | 0 No |
There could be many possibilites:
1) Data are getting rejected due to primary key violation
2) The conditions given in filter or router or update are
satisfying.
3) Make sure 'Enable Test load' option is not enabled.
4) Check for any post sql override in the session
Properties.
| Is This Answer Correct ? | 1 Yes | 1 No |
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
without table how to come first record only in oracle?
what is casual dimension?
In informatics server which files are created during the session rums?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
What is sorter transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
Where is metadata stored?
Teradata 
