Interested to Buy Any Domain ? << Click Here >> for more details...
I have a text file name x
With a text message. Word informatica
Is repeated for n number of times.
How to count the number of occurrence
Of word informatica
Of word informatic in this file x.
- 1 Answers
- 3502 Views
- Wipro, I also Faced
- E-Mail Answers
After SQ take exp trans
exp :
V_COUNT=V_COUNT+1
O_COUNT=V_COUNT
Aggr trans :
COUNT(O_COUNT)
| Is This Answer Correct ? | 0 Yes | 2 No |
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
How to generate a single mapping for both the historical and incremental load.
PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U
what is lookup ?
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
What is decode in static cache?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
Teradata 
