Cognizant Interview Question

Informatica without using Router, Filter, Expression, Seq gen, ranker, variables, update strategy load the target table with RDBMs source data having employees data having eids starting from 1-100 in two different targets by one having divisible by 5 and another with the rest

Interview Answer

Anonymous

Mar 17, 2018

I used SQL query with mod(Eid,5) in one target with SQ and another with SQL query Eid not in above mod

1