Suresh ETL Trainer
Suresh ETL Trainer
  • Видео 100
  • Просмотров 151 414

Видео

Update Strategy Transformation with SCD1 in Informatica
Просмотров 134Месяц назад
Update Strategy Transformation with SCD1 in Informatica
ETL Unit Testing Template with Example (With Audio)
Просмотров 3783 месяца назад
ETL Unit Testing Template with Example (With Audio)
ETL Unit Testing Template with Example
Просмотров 2024 месяца назад
ETL Unit Testing Template with Example
Worklets in informatica with example
Просмотров 5525 месяцев назад
Worklets in informatica with example
What are different types of partitioning in Informatica
Просмотров 1,8 тыс.6 месяцев назад
What are different types of partitioning in Informatica
Difference between Informatica PC and IICS
Просмотров 6796 месяцев назад
Difference between Informatica PC and IICS
Informatica Interview Questions-Sequence Generator NextVal & CurVal
Просмотров 5756 месяцев назад
Informatica Interview Questions-Sequence Generator NextVal & CurVal
How to improve Performance of informatica Workflow
Просмотров 8226 месяцев назад
How to improve Performance of informatica Workflow
Frequently asked SQL queries for interview || Top SQL Queries
Просмотров 1,4 тыс.7 месяцев назад
Frequently asked SQL queries for interview || Top SQL Queries
Informatica Calls Started || Points to remember to clear the Interview's
Просмотров 1 тыс.7 месяцев назад
Informatica Calls Started || Points to remember to clear the Interview's
Different Ways to set Dependency between Workflows in Informatica
Просмотров 3487 месяцев назад
Different Ways to set Dependency between Workflows in Informatica
Dynamic File Generation in informatica
Просмотров 5568 месяцев назад
Dynamic File Generation in informatica
Unix Commands Used in Informatica Power Center Part-2
Просмотров 7588 месяцев назад
Unix Commands Used in Informatica Power Center Part-2
Unix Commands Used in Informatica Power Center Part-1
Просмотров 9808 месяцев назад
Unix Commands Used in Informatica Power Center Part-1
Difference Between Versioned & Non-Versioned Repository in Informatica
Просмотров 2418 месяцев назад
Difference Between Versioned & Non-Versioned Repository in Informatica
Difference Between Versioned & Non-Versioned Repository in Informatica
Просмотров 1888 месяцев назад
Difference Between Versioned & Non-Versioned Repository in Informatica
Different ways to perform Migration / Deployment of Informatica Code
Просмотров 1,6 тыс.8 месяцев назад
Different ways to perform Migration / Deployment of Informatica Code
Key points to remember before design your ETL Mapping
Просмотров 8379 месяцев назад
Key points to remember before design your ETL Mapping
Why Look up Transformation is active || Lookup Policy on Multiple Match
Просмотров 4729 месяцев назад
Why Look up Transformation is active || Lookup Policy on Multiple Match
List File Approach in Informatica with Example
Просмотров 4379 месяцев назад
List File Approach in Informatica with Example
Built in Variables in Informatica
Просмотров 4859 месяцев назад
Built in Variables in Informatica
Naming Conventions in Informatica(ETL)
Просмотров 4099 месяцев назад
Naming Conventions in Informatica(ETL)
Informatica Interview Questions Part -13
Просмотров 5669 месяцев назад
Informatica Interview Questions Part -13
Test Case Document || Test Case Creation In Informatica
Просмотров 62210 месяцев назад
Test Case Document || Test Case Creation In Informatica
Standardizer Transformation In Informatica Data Quality (IDQ)
Просмотров 31510 месяцев назад
Standardizer Transformation In Informatica Data Quality (IDQ)
What are the things you should do/don't after joining to Project
Просмотров 33810 месяцев назад
What are the things you should do/don't after joining to Project
Explain Common ETL(Informatica) Bugs/Defects faced in your Project
Просмотров 76910 месяцев назад
Explain Common ETL(Informatica) Bugs/Defects faced in your Project
Error Table Concept in Informatica Detail Explanation
Просмотров 35710 месяцев назад
Error Table Concept in Informatica Detail Explanation
ETL Project Flow Explanation in Simple Terms
Просмотров 65410 месяцев назад
ETL Project Flow Explanation in Simple Terms

Комментарии

  • @satyak701
    @satyak701 5 дней назад

    very nicely explained sir, thank you so much

  • @PurandarUppari
    @PurandarUppari 7 дней назад

    Hi Sir, I am following you from a long ago, your a very good teacher who are going to learn informatica.. I have learn a lot from your videos on Power center.. I can easily understand and your way of explanation also is very intresting. but this video has a lot of disturbance and video quality also not good sir. can u please take care of this little bit issues it would be helpful for us. thank you sir for giving good knowledge for us..

  • @officeprofessionals149
    @officeprofessionals149 8 дней назад

    Your audio is not clear

  • @kentaurescarroll4256
    @kentaurescarroll4256 15 дней назад

    56122 Lynch Tunnel

  • @gnanendray3004
    @gnanendray3004 22 дня назад

    HI Suresh in interview they have asked how you load the fact and dimension tables?can you please explain?

  • @javeedpatayit-r5b
    @javeedpatayit-r5b 22 дня назад

    Thank you Very much ...and I have request pls do one video for to face client interview on informatica

  • @GnanendraY-z2p
    @GnanendraY-z2p 22 дня назад

    Thank you so much Suresh I have attended many interviews in every interview they have asked I was unable to answer now I can understand.

  • @clairemacduff889
    @clairemacduff889 23 дня назад

    992 Gerlach Freeway

  • @VinayKumar-rx1hp
    @VinayKumar-rx1hp 27 дней назад

    Thank you for this

  • @budhahemalatha6440
    @budhahemalatha6440 29 дней назад

    Sir i have completed my informatica powercenter etl developer course,i would like to learn iics also ,please help me to choose cdi,cai,idmc,di,which one i need to learn sir.

  • @arijitroy4267
    @arijitroy4267 Месяц назад

    How is it different from Lookup? We can do the same thing in Lookup as well

  • @Naveenasworldd
    @Naveenasworldd Месяц назад

    Can we just get the count of records in source qualifier alone without any fields?

  • @RichardsTruman
    @RichardsTruman Месяц назад

    9300 Boyer Union

  • @nikhilsharma-jj6vd
    @nikhilsharma-jj6vd Месяц назад

    Please create a Playlist for snowflake from start to end

  • @biomedicaresolutions8031
    @biomedicaresolutions8031 Месяц назад

    Informatica tool ends in next 2 years ?

    • @sureshetltrainer
      @sureshetltrainer Месяц назад

      It never...it may be old ..but all new ETL tools based on informatica only...

  • @rakeshkumarpaul5881
    @rakeshkumarpaul5881 Месяц назад

    Sir datastage is good ??

  • @devanshushekhar1126
    @devanshushekhar1126 Месяц назад

    How to do connection informatica to Kafka for streaming data can you make video on it.

  • @soma-d7q
    @soma-d7q 2 месяца назад

    Can you tell me difference b/w Data Quality vs Data profile ?

  • @bayikadisuneel1424
    @bayikadisuneel1424 2 месяца назад

    Sir informatica developer,job supporting is any possibile sir

  • @shyamkumar4107
    @shyamkumar4107 2 месяца назад

    You said that dynamic cache concept is used if we encounter multiple records on one id, but my question is we can delete duplicate records in many ways. why should we use this dynamic cache concept? and one more question is in dynamic lookup, we are already comparing values with the associated port, then why we are giving in condition tab again?

    • @Adikes_InfoTech
      @Adikes_InfoTech Месяц назад

      The first reason for using dynamic lookup to improve the performance of the job, if you use other ways to remove duplicates the performance will degrade. With condition only the lookup will work.

  • @shyamkumar4107
    @shyamkumar4107 2 месяца назад

    Can you explain XML transformation with the help of mapping sir? and also Parameterization.

  • @apoorvkansal9266
    @apoorvkansal9266 3 месяца назад

    Hi Sir, is it right to say that Source Qualifier is somewhat similar to Catalyst Optimizer(Spark Sql Engine) used in Spark? Main difference being optimization and techniques are outdated and for handling only GBs of data when it comes to Source Qualifier of Informatica.

  • @vinoseetharaman
    @vinoseetharaman 3 месяца назад

    How to check missing records in target in informatica Powercentre

    • @sureshetltrainer
      @sureshetltrainer 3 месяца назад

      Thanks for watching please share with your friends

  • @SaRa-kj9ff
    @SaRa-kj9ff 3 месяца назад

    can i move to Etl Datastage to informatica could u pls gell me 😢😢 got a no call from Datastage ...can i get more call s from informativa pls tell me what dif between datastahe vs informatica pls rell me helllo

    • @sureshetltrainer
      @sureshetltrainer 3 месяца назад

      Both are ETL tools only... please give me call for more information 9060099974

  • @1112electronics
    @1112electronics 3 месяца назад

    Thanks for the great video

  • @1112electronics
    @1112electronics 3 месяца назад

    Thank you so much for the great video

  • @venkateshmangamolla
    @venkateshmangamolla 3 месяца назад

    every day we are trying to load the data into target the code is not into production still it in testing phase 1st day the vendor sends 10 columns with the header and coma separated and we load that file to target and next day the vendor sends 5 columns and 4 columns like this every day in the file but vendor is not changing any columns or add new columns and the vendor jumbling position of the columns and vendor is not pass null for missing columns this is the structure of the file need to load data without losing any record how will we load the data to target in informatica power center and IICS Kindly explain this scenario please...

  • @Manifestion_kannada
    @Manifestion_kannada 3 месяца назад

    Sir make video on etl retail project end to end testing r

  • @user-dz6it8wr6e
    @user-dz6it8wr6e 3 месяца назад

    Hi Sir . How to find workflow running last 6 months .Can you please help me on this

    • @sureshetltrainer
      @sureshetltrainer 3 месяца назад

      You can configure in working flow monitor

    • @user-dz6it8wr6e
      @user-dz6it8wr6e 3 месяца назад

      Sir if possible can you please explain this please.actually I am stucked.

  • @pavankalyan7231
    @pavankalyan7231 3 месяца назад

    Scenario : dynamic file structure I have to load the flat file using informatica power center whose structure is not static. Number of columns will get changed in the future run. Here is the source file: ex : first day file emp_id , e_name, e_city 1 xys wer 2 sdf sdf second day file emp_id , e_name, e_city ,e_zipcode , 1 xys wer 34543 2 sdf sdf 35345 In the sample file I have 3 columns right now but in the future I can get only 4 columns or I may get another set of new columns as well. I can't go and change the code every time in the production , I have to use the same code by handling this situation. Can you please explain this in interviewer asking this question kindly give me the solution for this one?

  • @saleemshaik5807
    @saleemshaik5807 3 месяца назад

    good explanation sir

  • @blushtoshine9293
    @blushtoshine9293 3 месяца назад

    Fabulous

    • @sureshetltrainer
      @sureshetltrainer 3 месяца назад

      Thank you so much.. please share with your friends

  • @tarun.b1999
    @tarun.b1999 3 месяца назад

    Is it possible to show in the tool

  • @amruthasukumaran1476
    @amruthasukumaran1476 3 месяца назад

    Wt to do when we have flat file as source

  • @alagandulasandeep9148
    @alagandulasandeep9148 4 месяца назад

    can you please explain regration testing,retesting ....etc for etl testers

  • @budhahemalatha6440
    @budhahemalatha6440 4 месяца назад

    Waiting for this topic sir,thank you so much

  • @bhanuroyal__1
    @bhanuroyal__1 4 месяца назад

    And also XML transformation explain chesi and mapping tho explain cheyandi sir

  • @bhanuroyal__1
    @bhanuroyal__1 4 месяца назад

    Can you upload video for stored procedures sir? Better you can show us practically in informatica tool sir so that it should be more clear for everyone.

  • @bayikadisuneel1424
    @bayikadisuneel1424 4 месяца назад

    Which institute which city

  • @Ramyamanepalli1897
    @Ramyamanepalli1897 4 месяца назад

    Sir u r videos are very usefull to everyone .explanation is also super .tq so much for uploading the videos

  • @sureshetltrainer
    @sureshetltrainer 4 месяца назад

    Hi ALL, There was some issue in Audio. I will try to re upload new one

  • @chaitanyaarkati9981
    @chaitanyaarkati9981 4 месяца назад

    There is no audio in this video..kindly check and reupload for us

    • @sureshetltrainer
      @sureshetltrainer 4 месяца назад

      Let me check

    • @Indian103
      @Indian103 4 месяца назад

      Yes.I'm no't able video sound. Plz check it.Where the problem occurred.

    • @sureshetltrainer
      @sureshetltrainer 4 месяца назад

      I will try to re upload

    • @AJITHkumar-lj7gp
      @AJITHkumar-lj7gp 4 месяца назад

      Complete video does not have audio

  • @bhanuroyal__1
    @bhanuroyal__1 5 месяцев назад

    XML transformation explain chesi and mapping tho explain cheyandi sir

  • @KrishnaveniBattina-w2d
    @KrishnaveniBattina-w2d 5 месяцев назад

    Can you please give us an example with date for the Key portioning.Thanks

  • @priyankapatre38
    @priyankapatre38 5 месяцев назад

    Hi one doubt if there are two target table one contain primary key and other contain foreign key how to set which target load first

    • @sureshetltrainer
      @sureshetltrainer 5 месяцев назад

      It should be parent table always first

    • @priyankapatre38
      @priyankapatre38 5 месяцев назад

      @@sureshetltrainer is there any option in target property to set up which target load first

    • @priyankapatre38
      @priyankapatre38 5 месяцев назад

      @@sureshetltrainer your videos are really helpful thanks and keep posting such videos

    • @sureshetltrainer
      @sureshetltrainer 5 месяцев назад

      @@priyankapatre38 enable constraint based load in session level

    • @sureshetltrainer
      @sureshetltrainer 5 месяцев назад

      @@priyankapatre38 keep watching and share with your friends

  • @sakshipardeshi2007
    @sakshipardeshi2007 5 месяцев назад

    What is exactly database partitioning...how do we configure it..

  • @sakshipardeshi2007
    @sakshipardeshi2007 5 месяцев назад

    Say I have 10 partitions does each partition launches one session while execution. Session as in database session?

  • @sharad7614
    @sharad7614 5 месяцев назад

    Thank u

  • @Vijay.Y
    @Vijay.Y 5 месяцев назад

    Great explanation Sir...!

  • @junedkhan-ge5mi
    @junedkhan-ge5mi 5 месяцев назад

    ITS WORK AS SCD1,2 IS THERE IS ANY OTHER USE OF DYNAMIC CACHE?

    • @sureshetltrainer
      @sureshetltrainer 5 месяцев назад

      It works as SCD 1 not scd2

    • @junedkhan-ge5mi
      @junedkhan-ge5mi 5 месяцев назад

      @@sureshetltrainer yess I had try when attempting to insert duplicate into target wf fail due to insert into dynamic cache why lookup error