for ex: in source 10 records are there with column sal. use
a filter transformation condition as Sal=TRUE and connect
to target. what will happen.
- 11 Answers
- 19800 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
I checked result.
Case 1: when you use filter condition sal=true
nothing will be moved to target table. session succeeded
but no data in target table.
Case 2: when you use only TRUE as filter condition.
all 10 records from source passes through filter to target
table .(in target table also we will get 10 records)
| Is This Answer Correct ? | 31 Yes | 0 No |
Answer / pushpa
by default filter condition has the TRUE that means don't
worry whether the incoming data numeric or string.all incoming
data passed to the next transformation or target.
if we assign a condition manually sal=True.session is executed
successfully but even single record is not loaded into the
target.
| Is This Answer Correct ? | 19 Yes | 0 No |
Answer / lokendra
if 'salary= true' ,no records will come to target.
if only 'true' it will pass all the 10 records.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / arvind s
Sorry guys, Answer 3 is completely wrong.
TRUE is not identified as a string by informatica, its
represented as a bit, just like a high or low, (1 or 0)
almost equivalent to a boolean.
So we can equate sal=TRUE but sal='TRUE' will result in
invalid mapping as said in answer3.
Thanks,
Arvind S
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / pradeepa
Hi,
If the comparing column is a varchar and if this true is
given in single quotes it will validate ,but here salary
for sure it must be a number and when we say salary=true it
will trow error,that expression wont be validated..
obviously mapping will get invalidated..so we cant evn run
the ,mapping.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / venkat
hi guys ans 3 totally wrong
see this,
1)suppose u given condition like sal=true ,the session will
successfully execute but no data load in to target.
2)suppose u given condition like sal='true' it's not
validated b'coz in filter true/false like 1/0.
3)suppose u given condition like onlt true ,the session will
successfully execute and all the data also loaded in to target.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shiva
nothing will happen when we use filter option it just check
the source record where all record are salary records or nor
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / mack
Answer 3 is correct. Whenever you trying to validate your
expression ,it will give you an error.
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / amit
it gives expression error because we used sal=true
expresssion insted of sal='any numeric value i.e. we have
to define numeric value in the expression
| Is This Answer Correct ? | 5 Yes | 10 No |
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
What are the different lookup cache(s)?
What are the join types in joiner transformation?
how to remove staging area
rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg
Why sorter is an active transformation?
How can we integrate different flat file data in a single mapping and with in a single execution
What are the joiner caches?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
Teradata 
